package project.service;

import project.pojo.Book;
import project.pojo.Page;

import java.sql.SQLException;
import java.util.List;

/**
 * @author d11yu
 */
public interface BookService {
    public void addBook(Book book);

    public void deleteBookById(Integer id);

    public void updateBookById(Book book);

    public Book queryBookById(Integer id) throws SQLException;

    public List<Book> queryAllBooks() throws SQLException;

    public Page<Book> getPage(int pn, int ecp, String urlAction) throws SQLException;

    public Page<Book> getPageByPrice(int pn, double minPrice, double maxPrice, int ecp, String urlAction) throws SQLException;
}
